Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Extracting named cells from multiple sources

Hi,    I have a number of project management templates that contain info such as project number, start and end date, RAG status etc. All files are in .xls format, sit in the same network folder, and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thanks for being patient!.  

 

Yes, there are three sheets.  I only want to pick up data from the first sheet as the second two are contain lookups and notes.

 

The pronlem I have is that 'One page Summary' isn't formated as a table. I need to select fields to convert into a query table from a small sample of the named celss you can see below the sheets.

 

A small sample of the One Page Summary sheet below:

artemus's avatar
artemus
Microsoft Employee
4 years ago

You need to piece together a single row from this table like:

Table.FromRecords({[#"Project Status" = PreviousStep[Column6]{1}, ...]})

 

Where Column6 is the column with the value for Project Status, and 1 is (row number - 1) of that value. Repeat this for all items in the table (Hopefullly no one moved stuff around in other workbooks). If done correctly you should have a table with 1 row.