Hello,
I am going to be importing a CSV file into a sheet weekly and need the column to line up properly. The Comma Seperated list I am importing does not account for spaces I need for the excel sheet. I made a dummy table below. Every person is ordering a shirt, a hat, shoes, or any combination of the three. To the right is how many they are ordering. I need to run a macro to shift cells from the shirt column if they don't equal shirt, while also keeping the quantities. Basically I want the first table to turn into the 2nd table by running a VBA. The order will always be SHIRT - HAT - SHOES
<tbody>
</tbody>
<tbody>
</tbody>
Anything Helps
THANK YOU!!!
I am going to be importing a CSV file into a sheet weekly and need the column to line up properly. The Comma Seperated list I am importing does not account for spaces I need for the excel sheet. I made a dummy table below. Every person is ordering a shirt, a hat, shoes, or any combination of the three. To the right is how many they are ordering. I need to run a macro to shift cells from the shirt column if they don't equal shirt, while also keeping the quantities. Basically I want the first table to turn into the 2nd table by running a VBA. The order will always be SHIRT - HAT - SHOES
NAME | SHIRT? | QTY | HAT? | QTY | SHOES? | QTY |
kyle | Shirt | 1 | Shoes | 2 | ||
john | Shoes | 5 | ||||
jack | Shirt | 3 | Hat | 1 | Shoes | 2 |
kevin | Hat | 2 | Shoes | 1 |
<tbody>
</tbody>
NAME | SHIRT? | QTY | HAT? | QTY? | SHOES? | QTY |
kyle | Shirt | 1 | Shoes | 2 | ||
john | Shoes | 5 | ||||
jack | Shirt | 3 | Hat | Shoes | 3 | |
kevin | Hat | 2 | Shoes | 1 |
<tbody>
</tbody>
Anything Helps
THANK YOU!!!