Jan 25 2023 06:57 AM
I need to insert into an Excel spreadsheet (which I'll call "integrative") the data coming from other spreadsheets, whose data may be in different column positions. I don't want to do it manually, i.e. copy and paste, but automatically the data from (for example) the column named 'LastName' in an external spreadsheet, is inserted exactly into the column named 'LastName' of the spreadsheet "integrative". Can this be done using Microsoft Query? Or maybe through Power Pivot? If so, can you explain me step by step? Thanks a lot.
Jan 25 2023 07:55 AM
=INDIRECT(ADDRESS(ROW(),MATCH(C$1,'another spreadsheet'!$1:$1,0),,,"another spreadsheet"))
Maybe with this formula. In the example the formula is copied down and to the right in order to add data from the "address" column into the 'integrative' sheet.
Jan 25 2023 08:40 AM