This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have the following dataset that I would like to transform but do not know how. I would like to take the records in the 'Purchase / Sale' field and turn them into field headers and then have the value associated with the record be placed under the new field header. Before and after shown below. I feel as though I can get the desired result by doing some extractions and merges but was wondering if there was a simpler way. Please let me know if anyone has any suggestions. Thanks in advance!