Forum Discussion
Helper Iuse a cell value to fill a column
Well, I did some movements and got what I was looking for. Basically, I load a copy of the same excel file and using the query editor, I took off all the columns but the one that have the country name on one of the cells. Them, I remove the previous rows (3) and them I used the function which keep the upper rows. At this point the only one I need if the first row, which has the Country name. Them I append the 2 tables. The result at this point looks like a new column added to the previous ones but the new column only have data in the first row, which is the country. Using the fill up function I populated the country name on all the rows and as the last step I have to remove the first row in this view. The final result, I got a new column with the country name for each Excel file I loaded.
Helper IWell, I did some movements and got what I was looking for. Basically, I load a copy of the same excel file and using the query editor, I took off all the columns but the one that have the country name on one of the cells. Them, I remove the previous rows (3) and them I used the function which keep the upper rows. At this point the only one I need if the first row, which has the Country name. Them I append the 2 tables. The result at this point looks like a new column added to the previous ones but the new column only have data in the first row, which is the country. Using the fill up function I populated the country name on all the rows and as the last step I have to remove the first row in this view. The final result, I got a new column with the country name for each Excel file I loaded.