Snap28.png
I want to make the left table the right table.
https://www.excelguru.ca/forums/show...0745-Transpose
Snap28.png
I want to make the left table the right table.
https://www.excelguru.ca/forums/show...0745-Transpose
Last edited by chief_abound; 07-28-2020 at 08:28 AM.
Hi chief,
Instead of doing like you show, try using a pivot table. Your example right table is bad as it has column heads the same word.
See this attached for an example: Transpose - use Pivot.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you so much!
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
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
I will be careful.
Being careful is not enough. You need to provide the link to other forums where you have crossposted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks