Change list Orientation

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Could you attach a sample file with the data you have and a sheet with the output you desire from that example?

Steve

Reply | Quote

Here’s an example of the two ways I need the data. I tried using a pivot table, but since I don’t have values I couldn’t set it up.

Reply | Quote

You do not appear to have attached anything?

Reply | Quote

Not sure what happened. I’ll try again.

Reply | Quote