Hello,
I have data that are in pairs of data of hrs and cost for a given process under a name and trying to transpose the data to columns for a given process so I can use an advanced filter.
Here is what my data looks like and it spans from Column C to Column KZ and goes down about 100 rows for 100 processes.
<tbody>
</tbody>
Output I am trying to get to:
<tbody>
</tbody>
I tried using copy/transpose and using an index/match formulas but I think the best way would be a macro but I'm open to formulas as well. Any help would be greatly appreciated!
I have data that are in pairs of data of hrs and cost for a given process under a name and trying to transpose the data to columns for a given process so I can use an advanced filter.
Here is what my data looks like and it spans from Column C to Column KZ and goes down about 100 rows for 100 processes.
Name 1 | Name 2 | Name 3 | Name 4 | |||||
Hrs | Cost | Hrs | Cost | Hrs | Cost | Hrs | Cost | |
Process 1 | 2.13 | 1827 | 0.44 | 160 | 1.44 | 966 | 0.44 | 357 |
Process 2 | 9.63 | 2005 | 0.5 | 131 | 2.5 | 485 | 1.75 | 465 |
Process 3 | 0.13 | 32 | 0 | 0 | 0 | 0 | 0.5 | 129 |
<tbody>
</tbody>
Output I am trying to get to:
Process 1 | Process 2 | Process 3 | ||||
Hrs | Cost | Hrs | Cost | Hrs | Cost | |
Name 1 | 2.13 | 1827 | 9.63 | 2005 | 0.13 | 32 |
Name 2 | 0.44 | 160 | 0.5 | 131 | 0 | 0 |
Name 3 | 1.44 | 966 | 2.5 | 485 | 0 | 0 |
Name 4 | 0.44 | 357 | 1.75 | 465 | 0.5 | 129 |
<tbody>
</tbody>
I tried using copy/transpose and using an index/match formulas but I think the best way would be a macro but I'm open to formulas as well. Any help would be greatly appreciated!