Transposing spreadsheet data to two columns of data

[gfcashmo]

I am goign to provide screenshots but i'm trying to convert a group of data in a spreadsheet to two rows of data. See below and screenshots of samples

I need to do this to get the format below for using postman to push data to an application
Any help anyone can give would be awesome and I thank you.


Spreadsheet data

Person group 1 group 2 group 3 group 4
Sam mgr worker
steve mgr supervisor tender maint
paul supervisor team lead trainer


I want to transpose this to:

sam mgr
sam worker
steve mgr
steve supervisor
steve tender
steve main
paul supervisor
paul team lead
paul trainer

 

[gfcashmo]

Sorry the formatting got messed up. Maybe refer to the images.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Want to convert data in spreadsheet to two columns of data
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

How about

=LET(d,D2:H1000,HSTACK(TOCOL(IF(d<>"",A2:A1000,1/0),2),TOCOL(d,1)))

 

[gfcashmo]

That got it. Many thanks

 

[Fluff]

You're welcome & thanks for the feedback.