UnPivot in Access - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

UnPivot in Access

Joe Rapp

2 years ago

I watched the UnPivot in Excel and Transpose in Access video. I love the concept, but would like to avoid Excel and perform the Un-Pivot in Access. Is this possible and could you provide a video if there is a way?
I am working with fields that show states "AL, FL, GA, MS, SC" as an example in the same field and want them to appear as:

AL
FL
GA
MS
SC

The field could contain one state and up to 58 states/provinces. I watched and implemented the Split function video and it worked. Now I want to list those filed so I can group them with the other states to perform pricing calculations. Make sense? If not, let me know. Thank you.

	Richard Rost @Reply 2 years ago
Sorry for the delay in responding to this. So, you're getting a single string with a bunch of states in it, comma-separated, and you want to break those out into individual records in a different table? To what end? What is your ultimate goal, and what do you want your final product to look like?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View