want to covert data from columns to row as per attached details
I want to capture start date and end date in single row for duplicate names
Name Start Date End Date
Aditya 01-Jul-23 30-Sep-23
Aditya 01-Oct-23 31-Dec-23
Aditya 01-Jan-24 31-Mar-24
Aditya 01-Apr-24 30-Jun-24
Aditya 01-Jul-24 30-Sep-24
Rajesh 26-Aug-23 30-Sep-23
Rajesh 01-Oct-23 31-Dec-23
Rajesh 01-Jan-24 31-Mar-24
Rajesh 01-Apr-24 30-Jun-24
Rajesh 01-Jul-24 07-Jul-24
Pavan 01-Jul-23 30-Sep-23
Pavan 01-Oct-23 31-Dec-23
There will be a better way, but, for the moment, try:
H8:Formula:
Please Login or Register to view this content.
I8, copied down:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Power Query
Please Login or Register to view this content.
All in one spill formula:
=LET(u,UNIQUE(A5:A37),tr,DROP(REDUCE("",u,LAMBDA(x,y,VSTACK(x,TOROW(FILTER($B$5:$D$37,$A$5:$A$37=y))))),1),HSTACK(u,IFNA(IF(tr=0,"",tr),"")))
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Another possible workaround to output an "array of arrays" (incl. headers) with MAP could be:
See attached, if needed...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks