Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  6. #6
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  7. #7
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  8. #8
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I'd like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

    I'd also like to go back the other way. If I have 5 categories in the first row and the values listed below, I'd like to create a list with the values in one column and the associated categories in the other.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

  12. #12
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

  14. #14
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

  15. #15
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

    Steve

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •