Hi all,
This might not be possible to do as I am unable to find a way to combine the information in a table into a Query to sort in a pivot table.
Below is extract of my table columns A - G, rows 1 -15, etc
It is currently in table format to produce a Query and Pivot Table, but what I would like the Query to do is to create a list of the below:
so the query list would show
Column 1 = Document Name
Column 2 = Date (row 1 below)
Column 3 = Area (row 2 below (south east parkland))
Column 4 = Stage (row 3 below)
Column 5 = Revision number (P01 for example which is on the same row as document name)
The table has to be displayed as it is for users to fill in.
The next thing is when a user fills in the next date column and enters the revision number of the row with document number (so different or same rows), the query would add in another row with the information I mentioned. I sort of duplication except for the revision number.
I am unsure if this is possible when I described, so any thoughts on how I could accomplish this if I can would be helpful.
I only manage to make this work to produce results in a pivot table by having extra columns with a xlookup formula to get the information needed, however it would only be pulling the most current column of information, i.e. the last populated cell of row 5, there would be no way to filter in a pivot table of every revision for a particular area, since area names would change for the same document number.
Thanks again for any suggestions. please ask if there is something that needs explaining more.
Wayne
This might not be possible to do as I am unable to find a way to combine the information in a table into a Query to sort in a pivot table.
Below is extract of my table columns A - G, rows 1 -15, etc
It is currently in table format to produce a Query and Pivot Table, but what I would like the Query to do is to create a list of the below:
so the query list would show
Column 1 = Document Name
Column 2 = Date (row 1 below)
Column 3 = Area (row 2 below (south east parkland))
Column 4 = Stage (row 3 below)
Column 5 = Revision number (P01 for example which is on the same row as document name)
The table has to be displayed as it is for users to fill in.
The next thing is when a user fills in the next date column and enters the revision number of the row with document number (so different or same rows), the query would add in another row with the information I mentioned. I sort of duplication except for the revision number.
I am unsure if this is possible when I described, so any thoughts on how I could accomplish this if I can would be helpful.
I only manage to make this work to produce results in a pivot table by having extra columns with a xlookup formula to get the information needed, however it would only be pulling the most current column of information, i.e. the last populated cell of row 5, there would be no way to filter in a pivot table of every revision for a particular area, since area names would change for the same document number.
Thanks again for any suggestions. please ask if there is something that needs explaining more.
Wayne
