Hey @kmkalanetra,
I think this post should accomplish what you need! Although you'll probably need to transpose it in your favourite spreadsheet program to match your screenshot. Also if it's important that the data be relative abundance, then you can use qiime feature-table relative-frequency to convert from plain frequency before following the above post.
Let me know if that works for you!