Macros for formatting a data dump
Closed
mch24
Posts
2
Registration date
Thursday May 30, 2013
Status
Member
Last seen
May 31, 2013
-
May 30, 2013 at 08:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 3, 2013 at 11:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 3, 2013 at 11:03 AM
Related:
- Macros for formatting a data dump
- Tmobile data check - Guide
- Macros in excel download - Download - Spreadsheets
- Gta 5 data download for pc - Download - Action and adventure
- Transfer data from one excel worksheet to another automatically - Guide
- Data transmission cable - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 30, 2013 at 11:01 AM
May 30, 2013 at 11:01 AM
Hi Mch24,
I don't think I understand you because it looks to me that you want to move column F to column C ("Supplier balance in Column B" is a typo, right?).
Do you maybe mean that all the supplier codes are in A3? If so, then how are they sperated?
Please shine some light on the confusion.
Best regards,
Trowa
I don't think I understand you because it looks to me that you want to move column F to column C ("Supplier balance in Column B" is a typo, right?).
Do you maybe mean that all the supplier codes are in A3? If so, then how are they sperated?
Please shine some light on the confusion.
Best regards,
Trowa
mch24
Posts
2
Registration date
Thursday May 30, 2013
Status
Member
Last seen
May 31, 2013
May 31, 2013 at 04:44 AM
May 31, 2013 at 04:44 AM
Hi Trowa,
Thanks for your reply.
The expected out put would be to put the supplier code in one column, Supplier name to the next column of supplier code and the supplier balance in the next column of supplier name.
In the input file all these are in cell A3, B3 and F6 for Supplier Code, Supplier name and Supplier balance respectively.
Appreciate your help.
Thanks,
Thanks for your reply.
The expected out put would be to put the supplier code in one column, Supplier name to the next column of supplier code and the supplier balance in the next column of supplier name.
In the input file all these are in cell A3, B3 and F6 for Supplier Code, Supplier name and Supplier balance respectively.
Appreciate your help.
Thanks,
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 3, 2013 at 11:03 AM
Jun 3, 2013 at 11:03 AM
Hi Mch24
If all the supplier codes are in A3, then how are they separated?
Is it with a space or comma or ....?
You can then use the Text to Columns option to separate your data (probably best to use a separate sheet for that).
Then transpose the row of data to column.
Best regards,
Trowa
If all the supplier codes are in A3, then how are they separated?
Is it with a space or comma or ....?
You can then use the Text to Columns option to separate your data (probably best to use a separate sheet for that).
Then transpose the row of data to column.
Best regards,
Trowa