Hello,
I have a the below table with x's (only mine is 100x300).
<tbody>
</tbody>
I spend an hour+ each day copying and pasting into the below format by copying sheet and=IF(Sheet1!A2="x",$A1,""), remove blanks, shift up, transpose, then split out over rows.
<tbody>
</tbody>
I've searched and searched online for a solution but even have trouble even describing my problem to google.
Does anyone have a better way of doing this and save my life?
Thank you in advance
I have a the below table with x's (only mine is 100x300).
Adam | John | Fred | Frank | |
Apples | x | x | x | |
Pears | x | |||
Bananas | x | x | x | |
Grapes | x | x | ||
Oranges | x |
<tbody>
</tbody>
I spend an hour+ each day copying and pasting into the below format by copying sheet and=IF(Sheet1!A2="x",$A1,""), remove blanks, shift up, transpose, then split out over rows.
Adam | Apples |
Adam | Bananas |
John | Bananas |
John | Grapes |
Fred | Apples |
Frank | Apples |
Frank | Pears |
Frank | Bananas |
Frank | Grapes |
Frank | Oranges |
<tbody>
</tbody>
I've searched and searched online for a solution but even have trouble even describing my problem to google.
Does anyone have a better way of doing this and save my life?
Thank you in advance