Spreadsheet: 821111d1678455606-need-help-in-formula-to-pick-all-the-headers-by-order-number-input-sample-2-
Sheet: Sheet1

 | 2023-01-01 00:00:00 |  |  |  |  |  |  | 2023-01-02 00:00:00
ORDER# | TODAY CUTTING RECEIVED | TODAY TRIMS RECIVED | FEEDING UNTIL LAST DATE | TODAY FEEDING | TODAY LINE INPUT | TODAY LINE STITCHED | TODAY LINE DROPPED | TODAY CUTTING RECEIVED | TODAY TRIMS RECIVED | FEEDING UNTIL LAST DATE | TODAY FEEDING | TODAY LINE INPUT | TODAY LINE STITCHED | TODAY LINE DROPPED
123-2023
124-2023
125-2023
I need to make this daily production sheet having the headers but in this format can not create pivots and extract summerized reports.
Is this possible by formula that when I copy paste Order# then all the headers (will make a list of the yellow highlighted headers if required) pull to the next column by formula. Like below.
Actually I need to do that to extract all the reports by pivots, input the daily data and then refresh all pivots which I will make date wise/ line wise stiched/line wise dropped/ and so on…
OR any other our honorable expert can help me in this to tell me any way how can I make the report where I can put pivots and summerize all the data easily.
Every new Order# will have all the headers infront of (next column)
RESULT
Line# | Order# | Order QTY | [NAME] required | 2023-01-01 00:00:00 |  |  | 2023-01-02 00:00:00
1 | 123-2023 |  | TODAY CUTTING RECEIVED
1 | 123-2023 |  | TODAY TRIMS RECIVED | 123-2023 | 1 | TODAY TRIMS RECIVED | 123-2023 | 1 | TODAY TRIMS RECIVED
1 | 123-2023 |  | FEEDING UNTIL LAST DATE | 123-2023 | 1 | FEEDING UNTIL LAST DATE | 123-2023 | 1 | FEEDING UNTIL LAST DATE
1 | 123-2023 |  | TODAY FEEDING | 123-2023 | 1 | TODAY FEEDING | 123-2023 | 1 | TODAY FEEDING
1 | 123-2023 |  | TODAY LINE INPUT | 123-2023 | 1 | TODAY LINE INPUT | 123-2023 | 1 | TODAY LINE INPUT
1 | 123-2023 |  | TODAY LINE STITCHED | 123-2023 | 1 | TODAY LINE STITCHED | 123-2023 | 1 | TODAY LINE STITCHED
1 | 123-2023 |  | TODAY LINE DROPPED | 123-2023 | 1 | TODAY LINE DROPPED | 123-2023 | 1 | TODAY LINE DROPPED
2 | 125-2023 |  | TODAY CUTTING RECEIVED | 124-2023 | 2 | TODAY CUTTING RECEIVED | 124-2023 | 2 | TODAY CUTTING RECEIVED
2 | 125-2023 |  | TODAY TRIMS RECIVED | 124-2023 | 2 | TODAY TRIMS RECIVED | 124-2023 | 2 | TODAY TRIMS RECIVED
2 | 125-2023 |  | FEEDING UNTIL LAST DATE | 124-2023 | 2 | FEEDING UNTIL LAST DATE | 124-2023 | 2 | FEEDING UNTIL LAST DATE
2 | 125-2023 |  | TODAY FEEDING | 124-2023 | 2 | TODAY FEEDING | 124-2023 | 2 | TODAY FEEDING
2 | 125-2023 |  | TODAY LINE INPUT | 124-2023 | 2 | TODAY LINE INPUT | 124-2023 | 2 | TODAY LINE INPUT
2 | 125-2023 |  | TODAY LINE STITCHED | 124-2023 | 2 | TODAY LINE STITCHED | 124-2023 | 2 | TODAY LINE STITCHED
2 | 125-2023 |  | TODAY LINE DROPPED | 124-2023 | 2 | TODAY LINE DROPPED | 124-2023 | 2 | TODAY LINE DROPPED
 |  |  |  | 125-2023 | 3 | TODAY CUTTING RECEIVED | 125-2023 | 3 | TODAY CUTTING RECEIVED
 |  |  |  | 125-2023 | 3 | TODAY TRIMS RECIVED | 125-2023 | 3 | TODAY TRIMS RECIVED
 |  |  |  | 125-2023 | 3 | FEEDING UNTIL LAST DATE | 125-2023 | 3 | FEEDING UNTIL LAST DATE
 |  |  |  | 125-2023 | 3 | TODAY FEEDING | 125-2023 | 3 | TODAY FEEDING
 |  |  |  | 125-2023 | 3 | TODAY LINE INPUT | 125-2023 | 3 | TODAY LINE INPUT
 |  |  |  | 125-2023 | 3 | TODAY LINE STITCHED | 125-2023 | 3 | TODAY LINE STITCHED
 |  |  |  | 125-2023 | 3 | TODAY LINE DROPPED | 125-2023 | 3 | TODAY LINE DROPPED