pivot_longer & pivot_wider Functions of tidyr Package in R | Reshape Data from Wide to Long Format

[@theecanmole]

Thanks for posting.

[@StatisticsGlobe]

You're very welcome! :)

[@MrManikprabhu]

Hii, is it possible to get pivot_wider result based on alphabetic order

[@cansustatisticsglobe]

Hello Manik, What do you like to order alphabetically? I didn't get that part well. Regards, Cansu

[@MrManikprabhu]

@@cansustatisticsglobe like i have a long table (3 columns (product1, product 2, and value of product 1 and 2) and 20 rows) when I do pivot_wider (names_from = "product1", values_from = "value"), I get the output but product names from product1 are not arranged alphabetically. Is it possible to arrange it?

[@cansustatisticsglobe]

@@MrManikprabhu If I got you correct, the names_sort argument would help you with what you want. I adapted the code to illustrate your case; see below: data

[@MrManikprabhu]

@@cansustatisticsglobe wow, cool... thank you so much for your effort...this is what I needed... thank you again

[@cansustatisticsglobe]

@@MrManikprabhu Welcome!