Alignment for Different column data

Question

Hi community,

I would like to ask on how do we do the alignment dynamically for data column when import the different set of excel data.

I have excel data which sometime empty for column A and appear in column B (incorrect position). Some data it appear in column A ( which is the correct one). I have used record ID to tag for each of data and the different set of data always start with ID 1.

My problem is if data starting appear in column B, i need to move it from column B to A, column C to B, column D to C , Column E to D, column F to E accordingly.

May i know how we usually solve this alignment issue dynmically without affecting those data already correct appear in column A?

Thank you.

AncientPandaman · Answer

@SH_94 
if it different excel files\sheets, I suggest to create a customize macro to process the data so the output is auto merged and align via fieldname.

dreldrel · Answer

Agree with @Qiu, it's good to provide some sample datasets. But one thing may be helpful is that you can use a select tool to rename column B to column A, then use a union tool to combine your data streams together by final column names. Hope this helps, feel free to like the comments

Qiu · Answer

@SH_94

Can you provide a set of data including sample input and desired output?