|First, a posting tip...|
Please click on the blue line at the end of this post and read the instructions on how to post data in this forum. Then please repost your data so that the columns line up.
That said, you seem to have changed your requirements. In your first post you wanted Data 1, Data 2 and Data 3 transposed from rows to columns.
In your second post you seem to have added the requirement of stripping out the text strings PF, EPF and PFSAL from the data lines. That is a very different requirement from your first post and makes the solution a bit more complex.
In addition, the PF for Person A is 1000 in your input and 10000 in your output. Is that a typo or a calculation?
Please repost your input and output, using the instructions found via the blue line at the end of this post, making sure that it is accurate, so that we can offer a solution that works for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.