Display selected fields from one sheet on a new sheet in alphabetical order 1

[johngiggs]

I have tried a few different things with VLOOKUP in Excel to try to display data from one sheet on a new sheet in alphabetical order, but was unsuccessful.

The data I want in the new sheet is in columns A and Q of sheet 1. If Q is not null print the value of column A and column Q in column A and B of sheet 2.

Ex.

Sheet 1:

Column A | ... | Column Q
item 1 | ... | data
item 2 | ... |
item 3 | ... | data2

Desired output on Sheet 2:

Column A | Column B
item 1 | data
item 3 | data2

For item 2 it should not be printed because sheet 1 column q is null.

Any help would be greatly appreciated.

Thanks,

John

 

[SkipVought]

hi,

You could use a PivotTable. You could use MS Query. Both would use your data in sheet 1 as the source.

Your data need to be structured as a TABLE. faq68-5184

THe easiest is Insert > Tables > PivotTable

My results (took about 10 seconds)

Column A  Column Q
item 1    data
item 3    data2

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[johngiggs]

Hi Skip,

Thank you for the help! I am using Google docs for this item and I took your suggestion and tried using a pivot table which worked great! The tutorial is available here:

http://googleenterprise.blogspot.com/2011/05/pivot-tables-now-in-google-spreadsheets.html

John