Hi,
I have a huge data sheet where I have many columns. And I want unique values of column 'D' should be listed Row wise in another sheet.
Sample data sheet:
COLUMN A B
ROW 1 123 abcd
ROW 2 223 aDcd
ROW 3 323 aFcd
ROW 4 423 aFcd
ROW 5 523 abcd
OUTPUT IN SUMMARY SHEET:
COLUMN A B C
Row1 abcd aDcd aFcd
PS: I will not know about any details until I download it from a sql database. So the values are not constant.
Please help.
I have a huge data sheet where I have many columns. And I want unique values of column 'D' should be listed Row wise in another sheet.
Sample data sheet:
COLUMN A B
ROW 1 123 abcd
ROW 2 223 aDcd
ROW 3 323 aFcd
ROW 4 423 aFcd
ROW 5 523 abcd
OUTPUT IN SUMMARY SHEET:
COLUMN A B C
Row1 abcd aDcd aFcd
PS: I will not know about any details until I download it from a sql database. So the values are not constant.
Please help.