Hi everyone! I need help with transposing repeating vertical data to horizontal data but retaining unique values only. Attached is the file containing original report and 'what I want' report.
Thanks in advance for any help that you can shareData_help.xlsx
Hi, Welcome to the forum
A little pivot will help
Ref the attachment
☚ Click ★ just below left if it helps, Boo?ath?
Hi mgcarino and welcome to the forum,
Doing a little Design formatting on the answer above you can make it look more like your example. See the attached.
One test is worth a thousand opinions.
Hi MarvinP and boopathiraja. Thank you for the alternate solutions on how to achieve the desired report. However, can you help me with a VB macro code on how to transpose all the data to meet 'what I want' format? I plan to just provide the users with a macro button that would help them fix the data based on the original report. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks