Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine multiple rows to one single row based on common ID.

I have some issue to shift data from rows to combine to just one row based on a common ID (column A)

Below is my original data set:

 

WIP_NOSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTY
ED8166102/10/2018 9:05:00 AM02/10/2018 9:05:00 AM210
ED8166202/10/2018 9:05:00 AM02/10/2018 9:05:00 AM210
ED8166302/10/2018 9:05:00 AM02/10/2018 9:06:00 AM210
ED8166402/10/2018 9:06:00 AM02/10/2018 9:06:00 AM210
ED8166522/10/2018 4:32:00 PM22/10/2018 4:33:00 PM210
ED8166623/10/2018 9:28:00 AM23/10/2018 9:28:00 AM210
ED8166724/10/2018 9:55:00 AM24/10/2018 9:56:00 AM210

 

I like to reshape it to something like this:

 

WIP_NOSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTYSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTYSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTYSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTYSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTYSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTYSTAGESSTART_TIMEEND_TIMESTATUSQTYREJECTED_QTY
ED8166102/10/2018 9:05:00 AM02/10/2018 9:05:00 AM210202/10/2018 9:05:00 AM02/10/2018 9:05:00 AM210302/10/2018 9:05:00 AM02/10/2018 9:06:00 AM210402/10/2018 9:06:00 AM02/10/2018 9:06:00 AM210522/10/2018 4:32:00 PM22/10/2018 4:33:00 PM210623/10/2018 9:28:00 AM23/10/2018 9:28:00 AM210724/10/2018 9:55:00 AM24/10/2018 9:56:00 AM210
Need Help