I have Column A,B,C,D in Excel, I need to read only column A,C,D dynamically. Data looks like below, I need to pick only Item,31-Jan-24 and 29-feb-24 and rest of other columns.
A B C D
Item | 31-Dec-23 | 31-Jan-24 | 29-Feb-24 |
A | 4,545,456 | 4,545,456 | 4,545,456 |
B | 545,654 | 545,654 | 545,654 |
C | 465,465,465 | 465,465,465 | 465,465,465 |
D | 752,436 | 752,436 | 752,436 |
E | 689,535 | 689,535 | 689,535 |
And in the Excel I have 2 Empty rows present above the first rows and 1 empty column IN front of Column A. How to do this ?
@Alteryxexpert see workflow attached does this help?
@Alteryxexpert Share your sample excel file.
what i understood is the input is having null rows and column and you want to avoid this.