•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Multiply the name on Column based on Row Header Data
Our take
Hello everyone,
I’m reaching out for assistance in transforming a dataset where I need to multiply names in a specific column based on the corresponding row header data. Despite my efforts using functions like FILTER, REPT, HSTACK, and VSTACK, I haven’t been able to achieve the desired view. After significant trial and error, I'm hoping to find a more effective solution. Any insights or strategies you could share would be greatly appreciated. Thank you for your help!
Best,
Xenylon
[link] [comments]
Hi All,
Seeking assistance on how I can formulate the view from left to the view on the right.
I've been using FILTER, REPT, HSTACK, VSTACK and other functions to get this view. However, I can't formulate this view that I need (been through a lot of trial and error)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel alternatives for data analysis#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#Excel compatibility#row zero#cloud-based spreadsheet applications#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#FILTER#REPT#HSTACK#VSTACK