I have data in these format is there any function or formula is available in excel to arrange data the way I want?
1.png
I want to arrange data in below format, I used transpose but it didn't work the way I want.
2.png
example.xlsx
I have data in these format is there any function or formula is available in excel to arrange data the way I want?
1.png
I want to arrange data in below format, I used transpose but it didn't work the way I want.
2.png
example.xlsx
Try the above in H3, Copy and paste it towards right
H3=INDEX($B$3:$F$3,CEILING(COLUMNS($H$3:H$3)/3,1))
and try below in H5, Copy and paste it across
=IFERROR(INDEX($B$4:$F$15,ROWS(H$4:H4)*3-3+MATCH(H$4,$A$4:$A$15,0),CEILING(COLUMNS($H$3:H$3)/3,1)),"")
please find the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Alternative solution in just 4 cells.
In the file attached the cells are highlighted in grey color.
Formula:Please Login or Register to view this content.
samba_ravi
Thanks these formula works for me. Its simple and easy to use.
Last edited by meraz; 11-26-2021 at 06:19 AM.
DJunqueira
Transpose formula is lengthy and its bit complicated for me to use, and i am unable to edit in excel sheet data.
Your duplicate thread has been CLOSED. Please continue here.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
AliGW still i have some quarry that i didn't mention in these post so i created new post.
As I said in your other thread, you need to read our rules and follow them. You may NOT post duplicate threads for any reason. Ask your questions here.
Please solve these also.
Attachment 757012
Attachment does not work: I attach file from your duplicate post.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks