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.
Can you provide a set of data including sample input and desired output?
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
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |