Hi I have a spreadsheet which I have merged cells in a row and I have to transpose these into columns, when I transpose into columns the data comes through every other cell.. Is there a formula which transposes the data every cell so I dont get a blank.
I have submitted an example (hope it works) of what I am after
Example.JPG
Hi Shaun,
Excel experts hate merged fields and your problem is just another reason. *If you could transpose your table (rotate it to the right) and fill down the colors and transpose it back, it would do what I think you want. The "Fill Down" feature is in a newer tool Excel has in Power Query. It is built into 2016 Excel. See an*example at:\http://www.excelguru.ca/blog/2014/09...n-power-query/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks