LinkBack URL
About LinkBacks
Hi!!
Can anyone tell me how I can best go about taking cells of information and 1) transposing them 2) putting them into clusters that can be numbered for a report.
The best way that I can describe this is as follows with lists of vendors and costs:
Hi!!
Can anyone tell me how I can best go about taking cells of information and 1) transposing them 2) putting them into clusters that can be numbered for a report.
The best way that I can describe this is as follows with lists of vendors and costs:
It appears that you could do this with a pivot table. That's as far as I can take it without a sample workbook.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Sorry....Excel file attached. My apologies.
Power query solution
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Traditionally:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks